Quarterly Cash Flow Projection
The ABC Corporation First Quarter, 2006
Cash Received Beginning Cash Balance Cash Sales Collections Loans Total Cash Available Cash Disbursed Salaries and Wages Lease/Mortgage Insurance Office Supplies Utilities Repairs and Maintenance Operating Supplies Professional Fees Commissions Travel and Entertainment Purchases Advertising Transportation Other Total Disbursements Cash Position Loan Payment with Interest Capital Purchases Owner's Withdrawal Total Cash Paid Out End Of Month Estimate $52,552 23,821 59,014 15,121 $150,508 $14,752 1,659 1,041 5,404 7,316 4,378 2,805 3,437 13,716 3,734 4,140 1,957 14,776 12,352 $91,467 $8,214 2,080 12,500 $114,261 $36,247 JANUARY Actual $54,530 25,485 61,001 18,452 $159,468 $15,855 1,659 1,085 3,505 7,105 4,155 3,950 1,575 15,850 4,580 4,500 2,850 13,505 11,318 $91,492 $8,214 1,500 15,500 $116,706 $42,762 Variance ($1,978) (1,664) (1,987) (3,331) ($8,960) ($1,103) 0 (44) 1,899 211 223 (1,145) 1,862 (2,134) (846) (360) (893) 1,271 1,034 ($25) $0 580 (3,000) ($2,445) ($6,515) Estimate $36,247 23,819 62,394 12,329 $134,789 $12,890 1,422 956 4,646 8,212 4,161 3,114 3,097 12,293 4,061 4,830 1,841 12,681 12,794 $86,998 $7,318 2,004 5,000 $101,320 $33,469 FEBRUARY Actual $42,762 26,468 63,666 19,109 $152,005 $13,659 1,776 1,175 3,911 7,190 3,694 4,538 1,630 17,303 4,509 4,783 3,205 12,838 12,410 $92,621 $8,665 1,764 10,000 $113,050 $38,955 Variance ($6,515) (2,649) (1,272) (6,780) ($17,216) ($769) (354) (219) 735 1,022 467 (1,424) 1,467 (5,010) (448) 47 (1,364) (157) 384 ($5,623) ($1,347) 240 (5,000) ($11,730) ($5,486) Estimate $33,469 25,443 73,702 14,513 $147,127 $15,042 1,589 980 5,395 6,837 4,766 3,247 3,245 11,060 4,546 4,161 1,700 10,522 10,630 $83,720 $6,353 2,348 15,000 $107,421 $39,706 MARCH Actual $38,955 26,780 69,487 19,452 $154,674 $14,150 1,778 1,328 4,676 7,535 4,330 5,170 1,514 19,577 4,923 5,129 3,499 14,371 13,920 $101,900 $8,278 1,493 10,000 $121,671 $33,003 Variance ($5,486) (1,337) 4,215 (4,939) ($7,547) $892 (189) (348) 719 (698) 436 (1,923) 1,731 (8,517) (377) (968) (1,799) (3,849) (3,290) ($18,180) ($1,925) 855 5,000 ($14,250) $6,703
© Copyright, 2006, Jaxworks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalua
Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis.
If you are involved in financial analysis at any level, or want to learn more about MS Excel and suite this site is invaluable.
JaxWorks Small Business Spreadsheet Factory
spreadsheets, and associated MS Word, PDF and HTML ons. These are invaluable small business tools.
ides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory